2012-10-12 - 5196 - Service Request - Investigate and propose Fix for MRP job #mrpexecution #US

5196.100 - Service Request - Investigate and propose Fix for MRP job

Summary Description

Investigate and propose Fix for MRP job

Admin Info

Purpose
 5900 - Investigate and propose Fix for MRP job
Requested by
 Rahul Attarde
Issue Date
 10-12-2012
Resolved by
 Adithya
Resolved Date
 10-20-2012
Document Status
 Complete

Detailed Description

(Include Screen Shots if required )
Investigate and propose fix to improve NA MRP job processing time. Ideally the job should be finished before 8 am EST

Analysis and Recommendations

(Include Screen Shots if required)
It was observed that the report J_3AMBAC report was taking long time. The J_3AMBAC report is carried out mainly for correction of the Purchase reqs inconsistencies.
This report was suggested by SAP as the STO purchase requisitions were not deleted by MRP though the STO is created from the STO Pur.req, The STO Pur.req demand is not deleted and still showing in /AFS/MD04 of the supplying plant and is still participating in MRP and extra stock proposals were generated.

The report J_3AMBAC having a variant PURREQ_COR_REP.

As suggested the atributes that are to be changed in Variant PURREQ_COR_REP

1. Maintain the processing status as B and N. Processing status B – PO created, N – Not Edited (PO not created).
This is done to limit the selection of purchase reqs.
2. Un-flag the check box for General PR checks, under entity enhanced checks.
3. Selection of date may also limit the number of purchase reqs, The Puchase requisition date can be dynamically selected in variant.

oss.png
  1. Maintain the processing status as B and N in the variant. Processing status B – PO created, N – Not Edited (PO not created).With this change we can limit the purchase requisitions to be selected.
  2. Under enhanced entity checks un-flag the check box for General PR checks. The most of the inconsistencies will be with stock transfer purchase requisitions. So, this selection is not necessary.
  3. The selection of Purchase requisitions can also be limited with the requisition date. The date can be three months into past from the current date. This can be done with dynamic date selection in the variant.
In addition to the above there is an OSS note with which additional selection parameters can be added in the selection report like purchasing group, Item category etc. Once these parameters are added the purchase requisition selection can still be limited.

Note 1502150 - Some selection parameters missing in AFS report j_3ambac

We can analyze the run times once the above changes are done to the variant.

Resolution



Release Information

Provide link here to Release Notes